package com.ihisun.tmhcms.core.dao.projectdao;

import com.ihisun.tmhcms.core.vo.ProjectClassVo;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface ProjectClassDao extends JpaRepository<ProjectClassVo,Long> {

    @Query(value = "select * from p_project_class where state!=3 group by project_class_name",nativeQuery = true)
    public List<ProjectClassVo>findByStateNot();

    public ProjectClassVo findByProjectTypeId(String projectClassId);
}
